08 Spreadsheet Basics
A practical course that treats spreadsheets not simply as table tools, but as core data productivity tools for daily management, office work, customer tracking, sales summaries, surveys, reports, and basic automation.
0. Purpose and ultimate goal
The ultimate goal is to help learners structure data in tables, apply basic functions, and use sorting, filters, charts, and summaries to solve life and work problems with data. The course follows a professional training style centered on real datasets, timed tasks, repeated function practice, report outputs, and automation experiences.
Referenced professional training patterns
- Microsoft Excel and MOS-style function and table formatting practice structure
- Google Sheets-based collaborative data organization course pattern
- US/UK private office automation courses using practical datasets
- European vocational data literacy and report portfolio structure
Beginner · 1 Day
Beginner 1 Day Spreadsheet Basics Curriculum
A one-day practical course covering the spreadsheet interface, cell input, tables, basic calculations, sorting, saving, and sharing using Excel and Google Sheets.
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | Objective 1: spreadsheet basic and entry understanding. |
Hands-on practice using real spreadsheet tools with instructor demonstration and learner repetition.
Learners complete a practical task, submit an output, and revise it through feedback.
|
| Objective 2 | Objective 2: table and basic writing. |
Hands-on practice using real spreadsheet tools with instructor demonstration and learner repetition.
Learners complete a practical task, submit an output, and revise it through feedback.
|
| Objective 3 | Objective 3: data organization and result saving · sharing. |
Hands-on practice using real spreadsheet tools with instructor demonstration and learner repetition.
Learners complete a practical task, submit an output, and revise it through feedback.
|
| Platforms | Microsoft Excel, Google Sheets, Excel Online, Google Drive, OneDrive, Chrome, Microsoft Edge, Windows File Explorer |
|---|---|
| Instructor profile | Instructor should have spreadsheet, data organization, reporting, automation, and learner-support experience. |
| Target learners | Spreadsheet general citizens,, older adults, people with disabilities,, introductory, digitally vulnerable groups |
| Duration | 4-6 hours |
| Materials | PC or, internet, Microsoft or Google account, practice data file,, function guide, assessment |
| Deliverables | Table or file, basic function applicationtable, sorting · filter practice result, PDF |
| Assessment | Entry 20%, table 25%, basic function 30%, saving · sharing 15%, participation 10% |
Beginner · 3 Days
Beginner 3 Days Spreadsheet Basics Curriculum
A three-day course for creating spreadsheets for daily, learning, and work management with functions, sorting, filters, charts, and co-editing.
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | Objective 1: · learning · work data table with. |
Hands-on practice using real spreadsheet tools with instructor demonstration and learner repetition.
Learners complete a practical task, submit an output, and revise it through feedback.
|
| Objective 2 | Objective 2: basic function and data organization use. |
Hands-on practice using real spreadsheet tools with instructor demonstration and learner repetition.
Learners complete a practical task, submit an output, and revise it through feedback.
|
| Objective 3 | Objective 3: chart and editing with result sharing. |
Hands-on practice using real spreadsheet tools with instructor demonstration and learner repetition.
Learners complete a practical task, submit an output, and revise it through feedback.
|
| Platforms | Microsoft Excel, Google Sheets, Excel Online, Google Drive, OneDrive, Microsoft Teams, Google Workspace, Chrome, Edge |
|---|---|
| Instructor profile | Instructor should have spreadsheet, data organization, reporting, automation, and learner-support experience. |
| Target learners | General citizens,,, introductory,, small business owner, older adults · people with disabilities education learners |
| Duration | 12-18 hours |
| Materials | , internet, Microsoft/Google account, practice CSV · XLSX data, assignment, function table, chart materials |
| Deliverables | Managementtable, workmanagementtable, basic function table, chart 2, editing |
| Assessment | Data 25%, function use 25%, sorting · filter 20%, chart creation 20%, collaboration 10% |
Beginner · 1 Week
Beginner 1 Week Spreadsheet Basics Curriculum
A one-week course expanding spreadsheets into budgeting, attendance, inventory, survey summaries, and simple reports.
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | Objective 1: practical work type spreadsheet file design. |
Hands-on practice using real spreadsheet tools with instructor demonstration and learner repetition.
Learners complete a practical task, submit an output, and revise it through feedback.
|
| Objective 2 | Objective 2: basic function and use. |
Hands-on practice using real spreadsheet tools with instructor demonstration and learner repetition.
Learners complete a practical task, submit an output, and revise it through feedback.
|
| Objective 3 | Objective 3: spreadsheet based report writing. |
Hands-on practice using real spreadsheet tools with instructor demonstration and learner repetition.
Learners complete a practical task, submit an output, and revise it through feedback.
|
| Platforms | Microsoft Excel, Google Sheets, Excel Online, Google Forms, Microsoft Forms, Google Docs, Microsoft Word, Google Drive, OneDrive |
|---|---|
| Instructor profile | Instructor should have spreadsheet, data organization, reporting, automation, and learner-support experience. |
| Target learners | , introductory, college student, small business owner, general citizens,, data organization instructor |
| Duration | 20-30 hours |
| Materials | , internet, Microsoft/Google account, practice · sales · data, report, function guide |
| Deliverables | Management spreadsheet, table, table, chart report |
| Assessment | File design 25%, function · 30%, conditional formatting 15%, report 20%, feedback 10% |
Intermediate · 4 Weeks
Intermediate 4 Weeks Spreadsheet Basics Curriculum
A practical four-week course expanding into office work, customer management, sales tracking, survey analysis, basic dashboards, and automation.
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | Objective 1: work data entry · organization · system. |
Hands-on practice using real spreadsheet tools with instructor demonstration and learner repetition.
Learners complete a practical task, submit an output, and revise it through feedback.
|
| Objective 2 | Objective 2: analysis table and basic create. |
Hands-on practice using real spreadsheet tools with instructor demonstration and learner repetition.
Learners complete a practical task, submit an output, and revise it through feedback.
|
| Objective 3 | Objective 3: spreadsheet and form · automation tools. |
Hands-on practice using real spreadsheet tools with instructor demonstration and learner repetition.
Learners complete a practical task, submit an output, and revise it through feedback.
|
| Platforms | Microsoft Excel, Google Sheets, Excel Online, Google Forms, Microsoft Forms, Power Query basic, Google Looker Studio basic, Zapier, Make, Power Automate, Gmail, Outlook |
|---|---|
| Instructor profile | Instructor should have spreadsheet, data organization, reporting, automation, and learner-support experience. |
| Target learners | Education target, introductory, small business owner, educationorganization practitioner, customer management, dataanalysis introductory |
| Duration | 40-60 hours |
| Materials | , internet, Microsoft/Google account, practical work type sales · · data, form account, automation tools account, |
| Deliverables | Customer managementtable, salestable, analysis file, basic, form file, automation |
| Assessment | Dataorganization 25%, · 25%, 20%, form · automation 20%, presentation 10% |
Advanced · 8 Weeks
Advanced 8 Weeks Spreadsheet Basics Curriculum
An advanced project course connecting spreadsheets to employment, entrepreneurship, office automation, data reporting, and instructor portfolios.
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | Objective 1: practical work type spreadsheet portfolio creation. |
Hands-on practice using real spreadsheet tools with instructor demonstration and learner repetition.
Learners complete a practical task, submit an output, and revise it through feedback.
|
| Objective 2 | Objective 2: basic data analysis and automation. |
Hands-on practice using real spreadsheet tools with instructor demonstration and learner repetition.
Learners complete a practical task, submit an output, and revise it through feedback.
|
| Objective 3 | Objective 3: spreadsheet educationmaterials and practical work assessmentmaterials design. |
Hands-on practice using real spreadsheet tools with instructor demonstration and learner repetition.
Learners complete a practical task, submit an output, and revise it through feedback.
|
| Platforms | Microsoft Excel, Google Sheets, Excel Online, Google Forms, Microsoft Forms, Power Query, Power Automate, Office Scripts, Google Apps Script, Looker Studio, ChatGPT, Gemini, Copilot |
|---|---|
| Instructor profile | Instructor should have spreadsheet, data organization, reporting, automation, and learner-support experience. |
| Target learners | And startup, certification, education, small business owner, data practical work introductory, Digital Instructor course |
| Duration | 80-120 hours |
| Materials | , internet, Microsoft/Google account, automation tools account, practical work data,, assessment rubric, presentation |
| Deliverables | Spreadsheet portfolio 3, automation, analysis report, education assignment, function, materials |
| Assessment | Portfolio completion also 30%, function · analysis 25%, automation understanding 20%, educationmaterials 15%, presentation 10% |